Insert, Update, Delete, and Drop SQL Query
post⇾Main⇾Develop⇾Course⇾SQL Tutorial Mohammad Fathi 2024-05-09 10:30:00The fourth part of the training SQL.
What you will see in this video:
Create a column with an AUTO_INCREMENT option
Create a column with default DEFAULT value
Getting to know the WHERE conditional statement
How to add rows to the table with the INSERT INTO statement
How to edit a row in the table with the UPDATE statement
How to edit all rows of the table at once with the UPDATE statement
How to delete a row from the table with the DELETE FROM statement
How to delete all rows of the table at once with the DELETE FROM statement
How to delete the table itself and all its rows at once with the DROP TABLE statement